This is for the web? Not as big a problem as you'd think, and you can put away most of the toolbox.
You're trying a JOIN, essentially, right? As long as it's a left outer join (one primary view defines the rows for the table; external data fills those rows), you can do it by:
- In your "primary view", create JavaScript-addressable elements in the table. That means, essentially, creating table cells with unique ids derived from the "primary key" value if you are using "Treat as HTML". If you are displaying "using HTML", you'll need to substitute span or div elements created in passthru within the Domino-generated table cells.
- In each of the other databases, create a "Treat as HTML" (take that with a grain of salt) view that creates a JavaScript statement for each document to populate the target writable element in the master view. Use try-catch for each in order to get around any potential "in this view but not in that one" problems. Make the view template for these views "Treat contents as other: text/javascript". The viewtemplate should define the functions that run these statements.
- Refer to these views in the view template for the primary view in <script> tags.
- Call the JavaScript functions (the external views) from the onload of the "primary" view's viewtemplate.
Return to top
. . RE: displaying data from multiple n... (~Hal Zenrekonyl... 19.Dec.03) 
Print this page
